Skip to main content

Daily Invoice Supplementary Export

Introduction​

This is an export file that consists of invoices and credits that are generated on the day of export.

A Supplementary export should be generared every time a Daily Invoice Export is generated

Purpose​

The invoice export provides detailed job-line level information that enables suppliers to monitor transactions effectively. A supplementary export file, sent alongside the daily invoice export, offers concise, enquiry-level data that helps customers understand their payable amounts to suppliers.

File format​

Comma Separated Values - *.csv

Blocks​

Unlike the daily invoice export, the supplementary export does not include multiple line blocks; instead, it contains a single line entry for each invoice or credit record.

InvoiceAn invoice is a document that a supplier issues to a operator (lease), requesting payment for goods provided or services rendered.
Invoices are essential for record-keeping as well.

Below are examples of some goods and services that would be invoiced

  • Goods
    • Parts
      • Camshaft
      • Chassis
      • Brakes
    • Fluids
      • Engine Oil
      • Coolant
      • Synthetic Oil
      • Lubricant Oil
    • Accessories
      • Wind shield
      • Wipers
      • Navigation Systems
  • Services
    • Diagnosis
      • Engine Performance Checks
      • Emissions level Checks
      • Fuel Efficiency Checks
    • Improvements
      • Air filter replacements
      • Alignment corrections
      • Brake wear and Brake pad replacements
CreditA Credit is a way to adjust the final amount due, ensuring that the operator(lease) only pays for what they actually owe after any agreed-upon deductions

  • Discounts or Adjustments: A seller might provide a credit against an invoice if they offered a discount, or if there was an adjustment due to pricing errors or discrepancies in the products/services delivered.

  • Return of Goods: If the buyer returns goods that were previously purchased, the seller may issue a credit note against the invoice for the returned items. This reduces the outstanding balance.

  • Invoice Dispute: Sometimes, if there’s a disagreement about the amount billed (e.g., incorrect charges, overbilling, or faulty goods), a seller might issue a credit note to resolve the dispute.

Setup Required​

Generate Export​

A Scheduler should be created cloud scheduler with the following parameters

  • Name: Generate daily invoice supplementary export
  • Region: europe-west2
  • Frequency: 35 23 * * *
  • TimeZone: GMT London
  • Topic: projects/biddirect-2/topics/generateDailyInvoiceSupplementaryExport

  • Message body: a JSON object including the following parameters

    • dateTimeStamp: in format yyyy-MMM-dd ex 2022-Sep-30 , when skipped it will default to current date
    • leaseCompanyId: id of the lease company that the export is desired to be generated for